﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[tblMSX_server_restore_user]
#-- Purpose:		Stores a copy of users/groups that have been assigned to the
#--					role RestoreUser.  This is then used to filter the list
#--					of servers listed in the Restore Database Utility.
#--	Last Update:	04/10/2013
#--					For a complete history - please review comments in Version
#--					Control.
#------------------------------------------------------------------------------
*/
CREATE TABLE [dbo].[tblMSX_server_restore_user]
(
	[id]							int									IDENTITY(1,1) NOT NULL,
	[rst_server_name]				varchar(60)							NOT NULL,
	[rst_username]					varchar(255)						NOT NULL,
	[rst_should_hide]				bit									NOT NULL DEFAULT ((0)),
	CONSTRAINT						[PK_tblMSX_server_restore_user]		PRIMARY KEY CLUSTERED ([id] ASC)
)